﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using KPIS.GERP.GHRMS.MODEL;
using KPIS.GERP.GHRMS.IBLL;
using KPIS.GERP.GHRMS.DALFactory;
using KPIS.DBM;


namespace KPIS.GERP.GHRMS.BLL
{
    public class JobSiteLevelSystemControlBLL : IJobSiteLevelSystemControlBLL
    {
       // private static readonly IInquireDAL DAL = DataAccess.CreateInquire();
        // private InquireInfo inquireInfo = new InquireInfo();

        IDBManager dbManager = new DBManager(SystemInfo._DataProvider, SystemInfo._ConnectionString);
        public DataSet ListJobSiteLevelSystemControl()
        {
            DataSet ds = new DataSet();
            dbManager.Open();
            ds = dbManager.ExecuteDataSet(CommandType.Text, "select JSL.job_site_level_no from sys_system_controls as SC, hrm_mp_job_sites as JS, hrm_mp_job_site_levels as JSL where SC.dep_job_site_seq = JS.job_site_seq and JS.job_site_level_seq = JSL.job_site_level_seq ");
            dbManager.Dispose();
            //return DAL.ListInquire(new InquireInfo(0));
            return ds;
        }        
    }
}
